Farina in Natura - estratégia¶

Importando os dados e observações iniciais.¶

venda data_hora cliente mesa item produto quantidade valor_unit desconto total_item
0 460.0 01/02/2022 08:13 CONSUMIDOR M 1 119.0 SUCO DE LARANJA 400ML 1.0 14,5 0.0 14,5
1 460.0 01/02/2022 08:13 CONSUMIDOR M 1 121.0 PAO SOURDOUGH OVOS 1.0 15,5 0.0 15,5
2 461.0 01/02/2022 08:14 CONSUMIDOR M 2 119.0 SUCO DE LARANJA 400ML 1.0 14,5 0.0 14,5
3 461.0 01/02/2022 08:14 CONSUMIDOR M 2 121.0 PAO SOURDOUGH OVOS 1.0 15,5 0.0 15,5
4 465.0 01/02/2022 09:01 CONSUMIDOR M 1 46.0 QUICHE BACON 90G 2.0 19,5 0.0 39
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 25998 entries, 0 to 25997
Data columns (total 10 columns):
 #   Column      Non-Null Count  Dtype  
---  ------      --------------  -----  
 0   venda       25992 non-null  float64
 1   data_hora   25992 non-null  object 
 2   cliente     25992 non-null  object 
 3   mesa        22779 non-null  object 
 4   item        25922 non-null  float64
 5   produto     25992 non-null  object 
 6   quantidade  25992 non-null  float64
 7   valor_unit  25992 non-null  object 
 8   desconto    25992 non-null  float64
 9   total_item  25992 non-null  object 
dtypes: float64(4), object(6)
memory usage: 2.0+ MB

Limpeza e manipulação dos dados.¶

venda            6
data_hora        6
cliente          6
mesa          3219
item            76
produto          6
quantidade       6
valor_unit       6
desconto         6
total_item       6
dtype: int64
venda data_hora cliente mesa produto quantidade valor_unit desconto total_item
121 520.0 02/02/2022 16:57 CONSUMIDOR M0 BOMBOLONI NUTELLA 80G 2.0 12 0.0 24
122 520.0 02/02/2022 16:57 CONSUMIDOR M0 TARTELETE DE MORANGO 120G 1.0 18 0.0 18
123 520.0 02/02/2022 16:57 CONSUMIDOR M0 CROISSANT MUSSATRELA DE 1.0 25,5 0.0 25,5
894 856.0 11/02/2022 19:19 CONSUMIDOR M0 CROISSANT BRIE PARMA MEL DE 2.0 25,5 0.0 51
895 856.0 11/02/2022 19:19 CONSUMIDOR M0 VH SANTA HORTENSIA SAUVIG 1.0 59 0.0 59
venda data_hora cliente mesa produto quantidade valor_unit desconto total_item horario
0 460 2022-02-01 08:13:00 CONSUMIDOR M 1 SUCO DE LARANJA 400ML 1 14.5 0.0 14.5 2022-02-01
1 460 2022-02-01 08:13:00 CONSUMIDOR M 1 PAO SOURDOUGH OVOS 1 15.5 0.0 15.5 2022-02-01
2 461 2022-02-01 08:14:00 CONSUMIDOR M 2 SUCO DE LARANJA 400ML 1 14.5 0.0 14.5 2022-02-01
3 461 2022-02-01 08:14:00 CONSUMIDOR M 2 PAO SOURDOUGH OVOS 1 15.5 0.0 15.5 2022-02-01
4 465 2022-02-01 09:01:00 CONSUMIDOR M 1 QUICHE BACON 90G 2 19.5 0.0 39.0 2022-02-01
<class 'pandas.core.frame.DataFrame'>
Int64Index: 25992 entries, 0 to 25997
Data columns (total 10 columns):
 #   Column      Non-Null Count  Dtype         
---  ------      --------------  -----         
 0   venda       25992 non-null  int64         
 1   data_hora   25992 non-null  datetime64[ns]
 2   cliente     25992 non-null  object        
 3   mesa        25992 non-null  object        
 4   produto     25992 non-null  object        
 5   quantidade  25992 non-null  int64         
 6   valor_unit  25992 non-null  float64       
 7   desconto    25992 non-null  float64       
 8   total_item  25992 non-null  float64       
 9   horario     25992 non-null  object        
dtypes: datetime64[ns](1), float64(3), int64(2), object(4)
memory usage: 2.2+ MB

Creating a column name 'hora_minuto'¶

Creating the column "data" baseadao em "data_hora"¶

Extracting only the Date from 'data' column¶

'pt_BR.utf-8'
venda data_hora cliente mesa produto quantidade valor_unit desconto total_item horario hora minuto hora_minuto data hora_do_dia dia_da_semana tipo_de_dia item_count
0 460 2022-02-01 08:13:00 CONSUMIDOR M 1 SUCO DE LARANJA 400ML 1 14.5 0.0 14.5 2022-02-01 8 13 08:13:00 2022-02-01 manhã terça DDS 1
1 460 2022-02-01 08:13:00 CONSUMIDOR M 1 PAO SOURDOUGH OVOS 1 15.5 0.0 15.5 2022-02-01 8 13 08:13:00 2022-02-01 manhã terça DDS 1
2 461 2022-02-01 08:14:00 CONSUMIDOR M 2 SUCO DE LARANJA 400ML 1 14.5 0.0 14.5 2022-02-01 8 14 08:14:00 2022-02-01 manhã terça DDS 1
3 461 2022-02-01 08:14:00 CONSUMIDOR M 2 PAO SOURDOUGH OVOS 1 15.5 0.0 15.5 2022-02-01 8 14 08:14:00 2022-02-01 manhã terça DDS 1
4 465 2022-02-01 09:01:00 CONSUMIDOR M 1 QUICHE BACON 90G 2 19.5 0.0 39.0 2022-02-01 9 1 09:01:00 2022-02-01 manhã terça DDS 1

Verificando divergência dos dados¶

Creating a Column diference¶

total_item          53878.3
total_item_verif    22219.1
diference           31659.2
dtype: float64

Gerando um relatório dos dados divergentes¶

venda data produto quantidade valor_unit total_item total_item_verif
7039 3571 2022-04-29 CROISSANT 1 10.0 25.5 10.0
7047 3575 2022-04-29 CROISSANT 1 10.0 28.9 10.0
7054 3582 2022-04-29 CROISSANT 1 10.0 25.5 10.0
7072 3599 2022-04-30 CROISSANT 1 10.0 19.5 10.0
7074 3600 2022-04-30 CROISSANT IFOOD 1 12.0 51.0 12.0

Criando um arquivo HTML dos dados divergentes usando Plotly ("ts2" dataframe)¶

/home/claudio/results/Dados_divergentes_vendas.html

/home/claudio/farina_in_natura001/CSV

GRÁFICO 01¶

Exploração dos Dados¶

CROISSANT                       2393
PASTEL DE NATA 60G              1339
CROISSANT  AMENDOAS 100G         742
FOLHADO MACA 80G                 719
SANDUICHE DE PEPERONI BRIE       596
COOKIES 80G                      559
CROISSANT IFOOD                  534
SOURDOUGH AZEITONA E ALECRIM     517
FOLHADO FRANGO 160G              500
BOMBOLONI DOCE DE LEITE 80G      487
Name: produto, dtype: int64

Converting a Series to a dataframe and changing the namee of the column¶

produto quantidade
0 CROISSANT 2393
1 PASTEL DE NATA 60G 1339
2 CROISSANT AMENDOAS 100G 742
3 FOLHADO MACA 80G 719
4 SANDUICHE DE PEPERONI BRIE 596

Criando um arquivo HTML usando Plotly¶

GRÁFICO 02¶

Find the percentage of itens sold¶

CROISSANT                       0.092067
PASTEL DE NATA 60G              0.051516
CROISSANT  AMENDOAS 100G        0.028547
FOLHADO MACA 80G                0.027662
SANDUICHE DE PEPERONI BRIE      0.022930
COOKIES 80G                     0.021507
CROISSANT IFOOD                 0.020545
SOURDOUGH AZEITONA E ALECRIM    0.019891
FOLHADO FRANGO 160G             0.019237
BOMBOLONI DOCE DE LEITE 80G     0.018737
Name: produto, dtype: float64

Converting to a Dataframe¶

produto proporção
0 CROISSANT 0.092067
1 PASTEL DE NATA 60G 0.051516
2 CROISSANT AMENDOAS 100G 0.028547
3 FOLHADO MACA 80G 0.027662
4 SANDUICHE DE PEPERONI BRIE 0.022930
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 212 entries, 0 to 211
Data columns (total 2 columns):
 #   Column     Non-Null Count  Dtype  
---  ------     --------------  -----  
 0   produto    212 non-null    object 
 1   proporção  212 non-null    float64
dtypes: float64(1), object(1)
memory usage: 3.4+ KB

inserting a column Ranking based on the value of the column proporção¶

Criando um arquivo html usando Plotly¶

Gráfico 03¶

Inserir um gráfico de pizza da tabela acima¶

GRÁFICO 3A¶

Algumas métricas importantes¶

O número de diferentes itens vendido pela loja é: 212
A média de itens por venda é: 2.79 itens
O número médio de itens vendidos por período do dia é: 
hora_do_dia
manhã    3.046419
noite    2.663510
tarde    2.783376
Name: item_count, dtype: float64

Creating a plot with the TOP itens sold per period of the day¶

GRÁFICO 04¶

Creating a plot to show the TOP itens sold by month (fevereiro 2022 -outubro 2022)¶

GRÁFICO 05¶

Criar a váriavel mes baseada na variavel horario¶

/tmp/ipykernel_2908/1953160630.py:1: SettingWithCopyWarning:


A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy

Creating the plot¶

Creating a table and an animated frequencie line¶

horario item_count
0 2022-02-01 74
1 2022-02-02 88
2 2022-02-03 81
3 2022-02-04 110
4 2022-02-05 112

GRAFICO 06¶

GRAFICO 07¶

Grafico 08¶

Investigando dados atipicos¶

GRÁFICO 09¶

hora item_count
0 7 8
1 9 5
2 10 5
3 11 7
4 12 4
5 13 8
6 14 5
7 15 3
8 16 2254
9 17 3
10 18 1

GRÁFICO 10¶

Encontrados dados atípicos nos dias 23 de Junho de 2022 e 30 de Julho de 2022, portanto uma filtragem desses dados se faz necessária¶

Mais informações relevantes¶

Vendas dias de semana (DDS) vs Final de semana (FDS)¶

horario item_count
0 2022-02-01 74
1 2022-02-02 88
2 2022-02-03 81
3 2022-02-04 110
4 2022-02-07 61
horario item_count
0 2022-02-05 112
1 2022-02-06 121
2 2022-02-12 108
3 2022-02-13 186
4 2022-02-19 107

Vendas dia de semana(DDS)¶

O menor número de vendas em um dia de semana foi: 
1
O maior número de vendas em um dia de semana foi: 
241
O número médio de vendas em um dia de semana é: 
75.81005586592178

Vendas final de semana (FDS)¶

O menor número de vendas em um dia de fim-de-semana foi: 
65
O  maior número de vendas em um dia fim-de-semana foi: 
227
O número médio de vendas em um dia fim-de-semana é: 
133.73611111111111

Número de itens médios vendidos por cada pedido¶

O número médio de itens em cada venda por tipo de dia é: 
tipo_de_dia
DDS    2.650391
FDS    2.836230
Name: item_count, dtype: float64

Itens vendidos por tipo de dia¶

Grafico 10A¶

horario tipo_de_dia item_count
0 2022-02-01 DDS 74
1 2022-02-02 DDS 88
2 2022-02-03 DDS 81
3 2022-02-04 DDS 110
4 2022-02-05 FDS 112

Grafico 10B¶

Faturamento por tipo de dia (DDS x FDS)¶

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 179 entries, 0 to 178
Data columns (total 2 columns):
 #   Column      Non-Null Count  Dtype  
---  ------      --------------  -----  
 0   horario     179 non-null    object 
 1   total_item  179 non-null    float64
dtypes: float64(1), object(1)
memory usage: 2.9+ KB

Grafico 11¶

Gráfico 11B¶

Número de itens vendidos por dia da semana¶

horario item_count
0 2022-02-01 74
1 2022-02-02 88
2 2022-02-03 81
3 2022-02-04 110
4 2022-02-05 112

GAFICO 12¶

dia_da_semana horario item_count
0 domingo 2022-02-06 121
1 domingo 2022-02-13 186
2 domingo 2022-02-20 156
3 domingo 2022-02-27 86
4 domingo 2022-03-06 126
5 domingo 2022-03-13 145
6 domingo 2022-03-20 140
7 domingo 2022-03-27 121
8 domingo 2022-04-03 93
9 domingo 2022-04-10 77

Grafico 13¶

Plotly Express (px)¶

'/home/claudio/results/grafico13 - Vendas_agregadas_itens_dias_semana_PX.html'

Graphic Objects (go)¶

expr: syntax error: missing argument after ‘8’

Horário de vendas dos itens por dia da semana¶

/usr/share/atom/atom: bad option: --executed-from=/home/claudio/farina_in_natura001
/usr/share/atom/atom: bad option: --pid=7358

Modo Simples¶

Grafico 14¶

Modo Complexo - Graphic Objects¶

Distribuição de vendas por hora do dia¶

GRAFICO 15¶

How to use Graphics Objects¶

Distribuição de vendas por dia da semana e hora do dia¶

Grafico 16¶

Grafico 16B¶

Detalhamento do porcentual das vendas pelo periodo do dia¶

criando uma coluna no dataframe "transactions_filtrada_2"¶

'/home/claudio/results/grafico016B - percentual_vendas_hora_dia.html'

Grafico 17¶

Quantidade de itens vendidos por dia da semana e período¶

/usr/share/atom/atom: bad option: --executed-from=/home/claudio/farina_in_natura001
/usr/share/atom/atom: bad option: --pid=7505
expr: syntax error: missing argument after ‘8’
dia_da_semana hora_do_dia item_count
0 segunda manhã 587
1 segunda noite 1354
2 segunda tarde 548
3 terça manhã 545
4 terça noite 1359
5 terça tarde 619
6 quarta manhã 642
7 quarta noite 1403
8 quarta tarde 811
9 quinta manhã 526
10 quinta noite 1459
11 quinta tarde 729
12 sexta manhã 744
13 sexta noite 1575
14 sexta tarde 669
15 sábado manhã 1512
16 sábado noite 2096
17 sábado tarde 986
18 domingo manhã 2310
19 domingo noite 1793
20 domingo tarde 932
0      587
3      545
6      642
9      526
12     744
15    1512
18    2310
Name: item_count, dtype: int64

Grafico 18¶

Vendas por hora¶

item_count
hora
6 41
7 524
8 1289
9 1749
10 1817
11 1446
12 737
13 627
14 769
15 1249
16 1912
17 3279
18 2917
19 2416
20 2094
21 333

Apriori Algorithm, Method 1¶

All day results¶

Rule: ADICIONAL DE PRESUNTO -> ADICIONAL DE MUSSARELA
Support: 0.0061068702290076335
Confidence: 0.5416666666666666
Lift: 70.95833333333333
=====================================
Rule: CROISSANT -> ADICIONAL DE MUSSARELA
Support: 0.009395184967704051
Confidence: 0.8333333333333333
Lift: 4.038607474862455
=====================================
Rule: CROISSANT -> ADICIONAL DE PRESUNTO
Support: 0.006928948913681738
Confidence: 0.9076923076923077
Lift: 4.398975526465566
=====================================
Rule: AGUA MINERAL S/GAS 500ML -> CROISSANT
Support: 0.01996476805637111
Confidence: 0.4197530864197531
Lift: 2.0342615428936814
=====================================
Rule: PAO SOURDOUGH OVOS -> BOWL DE IOGURTE FRUTAS AVEIA
Support: 0.007868467410452143
Confidence: 0.24814814814814815
Lift: 9.107678799489145
=====================================
Rule: CROISSANT -> CAFE CATUAI VERMELHO C/LEITE G
Support: 0.007868467410452143
Confidence: 0.43506493506493504
Lift: 2.1084677985645546
=====================================
Rule: CROISSANT -> CAFE CATUAI VERMELHO G 200ML
Support: 0.013740458015267175
Confidence: 0.46799999999999997
Lift: 2.2680819578827545
=====================================
Rule: CROISSANT -> CAFE COLMEIA C/ LEITE G 200ML
Support: 0.00551967116852613
Confidence: 0.5280898876404494
Lift: 2.5592973211487915
=====================================
Rule: CROISSANT -> CAFE COLMEIA G 200ML
Support: 0.007633587786259542
Confidence: 0.4276315789473684
Lift: 2.0724433094688917
=====================================
Rule: CROISSANT -> LARANJA 400 ML
Support: 0.021374045801526718
Confidence: 0.6275862068965518
Lift: 3.041489215551587
=====================================
Rule: SUCO DE LARANJA 400ML -> CROISSANT BRIE PARMA MEL DE
Support: 0.005989430416911333
Confidence: 0.2451923076923077
Lift: 5.394864341085272
=====================================
Rule: CROISSANT IFOOD -> PASTEL DE NATA 60G IFOOD
Support: 0.005167351732237228
Confidence: 0.4356435643564356
Lift: 9.391151773405188
=====================================
Rule: MINI CROISSANT 25G KIT C 5 -> MINI CROISSANT PAIN DE CHOC
Support: 0.00540223135642983
Confidence: 0.2358974358974359
Lift: 5.046901172529314
=====================================
Rule: CROISSANT -> ADICIONAL DE PRESUNTO
Support: 0.005637110980622431
Confidence: 0.5
Lift: 72.16101694915254
=====================================

Convert a list to a Dataframe¶

Rule Support Confidence Lift
0 ADICIONAL DE PRESUNTO -> ADICIONAL DE MUSSARELA 0.0061068702290076335 0.5416666666666666 70.95833333333333
1 CROISSANT -> ADICIONAL DE MUSSARELA 0.009395184967704051 0.8333333333333333 4.038607474862455
2 CROISSANT -> ADICIONAL DE PRESUNTO 0.006928948913681738 0.9076923076923077 4.398975526465566
3 AGUA MINERAL S/GAS 500ML -> CROISSANT 0.01996476805637111 0.4197530864197531 2.0342615428936814
4 PAO SOURDOUGH OVOS -> BOWL DE IOGURTE FRUTAS A... 0.007868467410452143 0.24814814814814815 9.107678799489145
5 CROISSANT -> CAFE CATUAI VERMELHO C/LEITE G 0.007868467410452143 0.43506493506493504 2.1084677985645546
6 CROISSANT -> CAFE CATUAI VERMELHO G 200ML 0.013740458015267175 0.46799999999999997 2.2680819578827545
7 CROISSANT -> CAFE COLMEIA C/ LEITE G 200ML 0.00551967116852613 0.5280898876404494 2.5592973211487915
8 CROISSANT -> CAFE COLMEIA G 200ML 0.007633587786259542 0.4276315789473684 2.0724433094688917
9 CROISSANT -> LARANJA 400 ML 0.021374045801526718 0.6275862068965518 3.041489215551587
10 SUCO DE LARANJA 400ML -> CROISSANT BRIE PARMA ... 0.005989430416911333 0.2451923076923077 5.394864341085272
11 CROISSANT IFOOD -> PASTEL DE NATA 60G IFOOD 0.005167351732237228 0.4356435643564356 9.391151773405188
12 MINI CROISSANT 25G KIT C 5 -> MINI CROISSANT P... 0.00540223135642983 0.2358974358974359 5.046901172529314
13 CROISSANT -> ADICIONAL DE PRESUNTO 0.005637110980622431 0.5 72.16101694915254

Grafico 19¶

'/home/claudio/results/grafico19 - Aplicando_Apriori_Modelo_01.html'

Resultados - Manhã¶

expr: syntax error: missing argument after ‘8’
/usr/share/atom/atom: bad option: --executed-from=/home/claudio/farina_in_natura001
/usr/share/atom/atom: bad option: --pid=7649

Resultado da função "associantion_results_manha" período Manhã¶

Rule: ADICIONAL DE PRESUNTO -> ADICIONAL DE MUSSARELA
Support: 0.009764758100310697
Confidence: 0.5945945945945946
Lift: 40.5945945945946
=====================================
Rule: AGUA MINERAL S/GAS 500ML -> ADICIONAL DE MUSSARELA
Support: 0.005326231691078562
Confidence: 0.3243243243243244
Lift: 5.294947121034079
=====================================
Rule: CROISSANT -> ADICIONAL DE MUSSARELA
Support: 0.015090989791389259
Confidence: 0.918918918918919
Lift: 3.344627341396324
=====================================
Rule: CROISSANT -> ADICIONAL DE PRESUNTO
Support: 0.013315579227696404
Confidence: 0.9090909090909091
Lift: 3.3088559259803203
=====================================
Rule: CROISSANT BRIE PARMA MEL DE -> AGUA MINERAL SEM GAS 500 ML
Support: 0.007545494895694629
Confidence: 0.2
Lift: 5.006666666666667
=====================================
Rule: PAO SOURDOUGH OVOS -> BOWL DE IOGURTE FRUTAS AVEIA
Support: 0.024411895250776743
Confidence: 0.2972972972972973
Lift: 3.9170222854433385
=====================================
Rule: BOWL DE IOGURTE FRUTAS AVEIA -> SELECAO DE PAES GELEIA
Support: 0.010208610741233911
Confidence: 0.2674418604651163
Lift: 3.2570081709616594
=====================================
Rule: LARANJA 400 ML -> CAFE CATUAI VERMELHO C/LEITE G
Support: 0.007989347536617843
Confidence: 0.23684210526315788
Lift: 3.629967776584318
=====================================
Rule: COOKIES 80G IFOOD -> CROISSANT IFOOD
Support: 0.005770084332001775
Confidence: 0.619047619047619
Lift: 7.621389539422324
=====================================
Rule: CROISSANT OVOS BACON MEL -> CROISSANT BRIE PARMA MEL DE
Support: 0.007989347536617843
Confidence: 0.2
Lift: 4.506
=====================================
Rule: SUCO DE LARANJA 400ML -> CROISSANT BRIE PARMA MEL DE
Support: 0.00887705281846427
Confidence: 0.22222222222222224
Lift: 6.032128514056224
=====================================
Rule: CROISSANT IFOOD -> PASTEL DE NATA 60G IFOOD
Support: 0.008433200177541057
Confidence: 0.5428571428571428
Lift: 6.683372365339578
=====================================
Rule: SOURDOUGH 369G IFOOD -> CROISSANT IFOOD
Support: 0.008433200177541057
Confidence: 0.59375
Lift: 7.309938524590163
=====================================
Rule: SUCO DE LARANJA 400ML -> CROISSANT MUSSATRELA DE
Support: 0.006657789613848202
Confidence: 0.2459016393442623
Lift: 6.674896306537625
=====================================
Rule: CROISSANT OVOS BACON MEL -> SUCO DE LARANJA 400ML
Support: 0.008433200177541057
Confidence: 0.2289156626506024
Lift: 5.157469879518072
=====================================
Rule: MINI CROISSANT 25G KIT C 5 -> MINI CROISSANT PAIN DE CHOC
Support: 0.007101642254771416
Confidence: 0.2857142857142857
Lift: 5.646616541353383
=====================================
Rule: CROISSANT -> ADICIONAL DE PRESUNTO
Support: 0.009320905459387484
Confidence: 0.5675675675675677
Lift: 42.624324324324334
=====================================
Rule: AGUA MINERAL S/GAS 500ML -> CROISSANT
Support: 0.006657789613848202
Confidence: 0.2054794520547945
Lift: 3.354675402025015
=====================================
Rule: CROISSANT -> BOWL DE IOGURTE FRUTAS AVEIA
Support: 0.006213936972924989
Confidence: 0.29166666666666663
Lift: 4.470238095238095
=====================================
Rule: CROISSANT -> LARANJA 400 ML
Support: 0.006657789613848202
Confidence: 0.2054794520547945
Lift: 3.149287112105116
=====================================
Rule: PAO SOURDOUGH OVOS -> CROISSANT
Support: 0.005326231691078562
Confidence: 0.3076923076923077
Lift: 5.590570719602978
=====================================
Rule: PAO SOURDOUGH OVOS -> CROISSANT
Support: 0.005326231691078562
Confidence: 0.3076923076923077
Lift: 4.71585557299843
=====================================
Rule: CROISSANT -> SANDUICHE DE PEPERONI BRIE
Support: 0.006213936972924989
Confidence: 0.3783783783783784
Lift: 3.1928332827209234
=====================================

Converting the list to dataframe - Manhã¶

Rule Support Confidence Lift
5 PAO SOURDOUGH OVOS -> BOWL DE IOGURTE FRUTAS A... 0.024411895250776743 0.2972972972972973 3.9170222854433385
2 CROISSANT -> ADICIONAL DE MUSSARELA 0.015090989791389259 0.918918918918919 3.344627341396324
3 CROISSANT -> ADICIONAL DE PRESUNTO 0.013315579227696404 0.9090909090909091 3.3088559259803203
6 BOWL DE IOGURTE FRUTAS AVEIA -> SELECAO DE PAE... 0.010208610741233911 0.2674418604651163 3.2570081709616594
0 ADICIONAL DE PRESUNTO -> ADICIONAL DE MUSSARELA 0.009764758100310697 0.5945945945945946 40.5945945945946
16 CROISSANT -> ADICIONAL DE PRESUNTO 0.009320905459387484 0.5675675675675677 42.624324324324334
10 SUCO DE LARANJA 400ML -> CROISSANT BRIE PARMA ... 0.00887705281846427 0.22222222222222224 6.032128514056224
14 CROISSANT OVOS BACON MEL -> SUCO DE LARANJA 400ML 0.008433200177541057 0.2289156626506024 5.157469879518072
12 SOURDOUGH 369G IFOOD -> CROISSANT IFOOD 0.008433200177541057 0.59375 7.309938524590163
11 CROISSANT IFOOD -> PASTEL DE NATA 60G IFOOD 0.008433200177541057 0.5428571428571428 6.683372365339578
9 CROISSANT OVOS BACON MEL -> CROISSANT BRIE PAR... 0.007989347536617843 0.2 4.506
7 LARANJA 400 ML -> CAFE CATUAI VERMELHO C/LEITE G 0.007989347536617843 0.23684210526315788 3.629967776584318
4 CROISSANT BRIE PARMA MEL DE -> AGUA MINERAL SE... 0.007545494895694629 0.2 5.006666666666667
15 MINI CROISSANT 25G KIT C 5 -> MINI CROISSANT P... 0.007101642254771416 0.2857142857142857 5.646616541353383
13 SUCO DE LARANJA 400ML -> CROISSANT MUSSATRELA DE 0.006657789613848202 0.2459016393442623 6.674896306537625
17 AGUA MINERAL S/GAS 500ML -> CROISSANT 0.006657789613848202 0.2054794520547945 3.354675402025015
19 CROISSANT -> LARANJA 400 ML 0.006657789613848202 0.2054794520547945 3.149287112105116
18 CROISSANT -> BOWL DE IOGURTE FRUTAS AVEIA 0.006213936972924989 0.29166666666666663 4.470238095238095
22 CROISSANT -> SANDUICHE DE PEPERONI BRIE 0.006213936972924989 0.3783783783783784 3.1928332827209234
8 COOKIES 80G IFOOD -> CROISSANT IFOOD 0.005770084332001775 0.619047619047619 7.621389539422324
1 AGUA MINERAL S/GAS 500ML -> ADICIONAL DE MUSSA... 0.005326231691078562 0.3243243243243244 5.294947121034079
20 PAO SOURDOUGH OVOS -> CROISSANT 0.005326231691078562 0.3076923076923077 5.590570719602978
21 PAO SOURDOUGH OVOS -> CROISSANT 0.005326231691078562 0.3076923076923077 4.71585557299843

Apriori Algorithm, Method 2¶

Transformando o rsultado da função "apriori_results_method_2" em um DATAFRAME¶

Fazendo a limpeza do DATAFRAME¶

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 60 entries, 0 to 59
Data columns (total 9 columns):
 #   Column              Non-Null Count  Dtype  
---  ------              --------------  -----  
 0   antecedents         60 non-null     string 
 1   consequents         60 non-null     string 
 2   antecedent support  60 non-null     float64
 3   consequent support  60 non-null     float64
 4   support             60 non-null     float64
 5   confidence          60 non-null     float64
 6   lift                60 non-null     float64
 7   leverage            60 non-null     float64
 8   conviction          60 non-null     float64
dtypes: float64(7), string(2)
memory usage: 4.3 KB
antecedents consequents antecedent support consequent support support confidence lift leverage conviction
0 CROISSANT, ADICIONAL DE MUSSARELA ADICIONAL DE PRESUNTO 0.009395 0.007634 0.005637 0.600000 78.600000 0.005565 2.480916
1 CROISSANT, ADICIONAL DE PRESUNTO ADICIONAL DE MUSSARELA 0.006929 0.011274 0.005637 0.813559 72.161017 0.005559 5.303166
2 ADICIONAL DE PRESUNTO ADICIONAL DE MUSSARELA 0.007634 0.011274 0.006107 0.800000 70.958333 0.006021 4.943629
3 CROISSANT IFOOD PASTEL DE NATA 60G IFOOD 0.046389 0.011861 0.005167 0.111392 9.391152 0.004617 1.112008
4 PAO SOURDOUGH OVOS BOWL DE IOGURTE FRUTAS AVEIA 0.027246 0.031709 0.007868 0.288793 9.107679 0.007005 1.361476

Grafico 20¶

'/home/claudio/results/grafico20 - Apriori_Method_02_all_Day.html'
/usr/share/atom/atom: bad option: --executed-from=/home/claudio/farina_in_natura001
/usr/share/atom/atom: bad option: --pid=7796
expr: syntax error: missing argument after ‘8’
antecedents
(CROISSANT, ADICIONAL DE MUSSARELA)             132.319444
(CROISSANT, ADICIONAL DE PRESUNTO)              123.727273
(ADICIONAL DE PRESUNTO)                         123.727273
(CROISSANT)                                      29.852497
(BOMBOLONI DOCE DE LEITE 80G)                    13.857519
(CROISSANT IFOOD)                                13.610000
(BOMBOLONI NUTELLA 80G, PASTEL DE NATA 60G)      11.864259
(FOLHADO FRANGO 160G, PASTEL DE NATA 60G)        10.807043
(FOLHADO FRANGO 160G)                            10.014217
(CROISSANT  TRADICIONAL 80 G)                     9.120090
(MINI CROISSANT 25G KIT C 5)                      7.845827
(CAFE INTENSO CAPSULA P 50ML)                     7.815052
(BOMBOLONI NUTELLA 80G)                           6.464520
(CROISSANT  AMENDOAS 100G)                        5.951058
(SOURDOUGH 369G)                                  5.620532
(FOCACCIA FORMAGGIO 246G)                         5.281658
(AGUA MINERAL S/GAS 500ML)                        4.844972
(FOLHADO FRANGO 160G, BOMBOLONI NUTELLA 80G)      4.472770
(TORRADA FARINA 165G)                             4.391127
(QUICHE DE TOMATE SECO SALADA)                    4.124911
(CAFE EQUILIBRADO CAPSULA P)                      3.764748
(FOLHADO MACA 80G)                                3.569901
(SANDUICHE DE PEPERONI BRIE)                      3.489744
(CROISSANT, PASTEL DE NATA 60G)                   3.434391
(PASTEL DE NATA 60G)                              2.713261
(CAFE EQUILIBRADO CAPSULA G)                      2.396127
(FOLHADO FRANGO 160G, CROISSANT)                  2.354089
(CROISANT DE CROISSANT QUEIJO)                    2.236385
(PIZZA AL TAGLIO GORGONZOLA E)                    2.223856
(MINI CROISSANT 25G)                              1.825620
(SOURDOUGH SEMI INTEGRAL 370G)                    1.779085
(QUICHE DE BACON SALADA VERDE)                    1.442829
(QUICHE DE FRANGO ALHO PORO)                      1.378164
(MINI CROISSANT PAIN DE CHOC)                     1.369215
(MINI PAIN AU CHOCOLAT 35G)                       1.277934
(SOURDOUGH AZEITONA E ALECRIM)                    1.250919
Name: lift, dtype: float64